<CFQUERY NAME="getorders" DATASOURCE="#dsn#">
select *
from tblorders

</CFQUERY>

<CFQUERY NAME="getpayments" DATASOURCE="#dsn#">
select *
from tblpayments

</CFQUERY>

<cfoutput>
ORDERS
<cfdump var="#getorders#"><BR><BR>

PAYMENTS
<cfdump var="#getpayments#">



</cfoutput>